The plain text report files can be easily imported by other statistical number crunching or graphing programs.
When importing, you must keep in mind that the columns of text and numbers are separated by spaces, not tabs. Usually only the count tables will be useful for other number crunching since most statistical programs use whole numbers in their formulas.
If you were using Microsoft Excel, one of the reports would first have to be opened as a file from within Excel. Since each row of the table will be in one cell of the spreadsheet, data parsing operations must be performed.
The parsing should begin on the first row of responses to the question (choice A), not the column headings. Using this row will provide the best template for parsing the other rows and eventually the column headings.
With this cell (choice A) selected, choose Parse... from Excel’s Data menu (the Full Menu option must be active). When the Parse Line dialog box appears, click Guess. The values in this row will be broken out into separate cells.
After accepting the template by clicking OK, you will have created a template that can be used on the other data rows and the column headings of this question’s count table. If you parsed all the other rows using the template and deleted the rows with dashed lines, then this question’s count table would be ready for other formula applications or creation of charts.
